CREATE TABLE [dbo].[CertificationProgramRegistration]
(
[CertificationProgramRegistrationKey] [uniqueidentifier] NOT NULL,
[CertificationProgramKey] [uniqueidentifier] NOT NULL,
[UserKey] [uniqueidentifier] NOT NULL,
[RegistrationDate] [datetime] NOT NULL,
[GracePeriodDate] [datetime] NOT NULL,
[ExpirationDate] [datetime] NOT NULL,
[ActionManifest] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[RegistrationStatusCode] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CurrentStageName] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EarnedUnits] [decimal] (18, 9) NULL,
[FormattedCertificationNumber] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CertificationNumber] [int] NULL,
[CreatedOn] [datetime] NOT NULL,
[CreatedByUserKey] [uniqueidentifier] NOT NULL,
[UpdatedOn] [datetime] NULL,
[UpdatedByUserKey] [uniqueidentifier] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[CertificationProgramRegistration] ADD CONSTRAINT [PK_CertificationProgramRegistration] PRIMARY KEY CLUSTERED ([CertificationProgramRegistrationKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CertificationProgramRegistration_CertificationProgramKey] ON [dbo].[CertificationProgramRegistration] ([CertificationProgramKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CertificationProgramRegistration_CreatedByUserKey] ON [dbo].[CertificationProgramRegistration] ([CreatedByUserKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CertificationProgramRegistration_RegistrationStatusCode] ON [dbo].[CertificationProgramRegistration] ([RegistrationStatusCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CertificationProgramRegistration_UpdatedByUserKey] ON [dbo].[CertificationProgramRegistration] ([UpdatedByUserKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CertificationProgramRegistration_UserKey] ON [dbo].[CertificationProgramRegistration] ([UserKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CertificationProgramRegistration] ADD CONSTRAINT [FK_CertificationProgramRegistration_CertificationProgram] FOREIGN KEY ([CertificationProgramKey]) REFERENCES [dbo].[CertificationProgram] ([CertificationProgramKey])
GO
ALTER TABLE [dbo].[CertificationProgramRegistration] ADD CONSTRAINT [FK_CertificationProgramRegistration_RegistrationStatusRef] FOREIGN KEY ([RegistrationStatusCode]) REFERENCES [dbo].[RegistrationStatusRef] ([RegistrationStatusCode])
GO
ALTER TABLE [dbo].[CertificationProgramRegistration] ADD CONSTRAINT [FK_CertificationProgramRegistration_UserMain] FOREIGN KEY ([UserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO
ALTER TABLE [dbo].[CertificationProgramRegistration] ADD CONSTRAINT [FK_CertificationProgramRegistration_UserMain_CreatedBy] FOREIGN KEY ([CreatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO
ALTER TABLE [dbo].[CertificationProgramRegistration] ADD CONSTRAINT [FK_CertificationProgramRegistration_UserMain_UpdatedBy] FOREIGN KEY ([UpdatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO